package com.ruoyi.tongji.mapper;

import com.ruoyi.jinchuguanli.domain.Shangpin;
import com.ruoyi.tongji.domain.GuiGeSelect;
import com.ruoyi.tongji.domain.RequestQiTaTianJia;
import com.ruoyi.tongji.domain.ShangPinXiangQing;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.sql.Date;
import java.util.List;

@Mapper
public interface JieCunMapper {
    List<GuiGeSelect> selectGuiGeList();

    List<Shangpin> selectShangPinList(GuiGeSelect ggs);

    List<String> selectShengChanChangShangList();

    List<ShangPinXiangQing> selectShangPinChuRuXiangQing(@Param("startDate") Date startDate,@Param("endDate") Date endDate);

    List<ShangPinXiangQing> selectShangPinRuXiangQing(@Param("startDate") Date startDate,@Param("endDate") Date endDate);

    List<RequestQiTaTianJia> selectQiTaList(Integer i);

    int insertRequestQiTaTianJia(RequestQiTaTianJia rqt);

    RequestQiTaTianJia selectRequestQiTaTianJia(Long id);

    int updateQiTaTianJia(RequestQiTaTianJia qiTaTianJia);

    int deleteRequestQiTaTianJiaByIds(String[] toStrArray);
}
